package com.xjm.ips.mapper;

import com.xjm.ips.entity.AdjustSalary;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface AdjustSalaryMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(AdjustSalary record);

    int insertSelective(AdjustSalary record);

    AdjustSalary selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(AdjustSalary record);

    int updateByPrimaryKey(AdjustSalary record);

    //非左连接查询，只查询员工信息并拥有工资套账的员工信息
    List<AdjustSalary> selectEmployeeWithSalary(@Param("pageNo") Integer pageNo,
                                                @Param("pageSize") Integer pageSize, @Param("adjustSalary") AdjustSalary adjustSalary);

    Long getTotalOfInner(@Param("adjustSalary") AdjustSalary adjustSalary);

    AdjustSalary selectNewestSalary(Integer eid);

    //查询员工工号对应的工资账套金额
    AdjustSalary selectAllSalaryByEmpId(Integer eid);
}